Skip to main content
Feedback

Boomi for SAP walkthrough

Boomi for SAP enables you to ingest SAP data into Data Integration by defining SAP views and replicating them into your Target systems. You can perform historical migrations to keep your data pipelines synchronized.

Prerequisites

  • An active Boomi for SAP account.
  • Create and finalize the SAP views (the objects you want to replicate) in Boomi for SAP before connecting the Source.
  • Ensure your SAP/Boomi user account can access the views you want to replicate.
important

Without Boomi access to create table services (schemas), you cannot extract data from Boomi for SAP.

Supported SAP datatypes

When ingesting SAP data, the following SAP datatypes are supported and mapped:

  • CHAR, VARCHAR, STRING, SSTRING → String
  • NUMC → String (numeric text)
  • DATS → Date or String
  • TIMS → Time or String
  • INT1/2/4 → Integer
  • FLOAT, FLTP → Float/Decimal
  • DEC, CURR, QUAN, BCD → Decimal (check scaling)
  • RAW, RAWSTRING, XSTRING → Byte/Hex String
  • DATN, TIMN → String

Configuring Boomi for SAP integration

Procedure

Step 1: Creating views in Boomi for SAP

  1. Log in to Boomi for SAP.
  2. Create and finalize SAP views for each table or entity you want to ingest.
  3. Verify that the views return the correct columns and data types.

Step 2: Creating a connection in Data Integration

  1. Log in to the Data Integration console.
  2. Click + Create River on the left-hand menu.
  3. Select Source to Target River.
  4. From the Source list, choose Boomi for SAP.
  5. Under Set Up Data Source connection:
    • Choose an existing connection, or
    • Click New Connection to create a new one.
  6. Click Test Connection to confirm connectivity.
  7. Click Save.

Step 3: Selecting a Target

  1. Under Selected Data Target, choose your Target system.
  2. In Target Connection, select an existing connection or create a new one.
  3. Click Test Connection to verify the Target connection.
  4. In Data Loading Settings, provide the required details:
    • Database
    • Schema
  5. Expand Advanced Settings to configure additional options. To learn more, refer to the Advanced settings topic.

Step 4: Configuring the schema

The schema configuration opens in multi-table mode, which lets you replicate multiple SAP views.

note

Column names in the Schema tab and on the Target side are displayed with dashes (-) instead of dots (.), as they appear in Boomi for SAP, due to target system limitations.

  1. In the left panel, search Schemas (representing table service) and select the one you want to use. The related table is displayed in the right panel.
  2. Select the tables or views you want to replicate.
  3. For each table, you can configure the following settings:
    • Click Mapping to review and manage column mappings, including data types, modes, and keys. Options include All Columns, Match Key, and Cluster.
    • Click Table Source Settings to define how to extract data.
      • Extraction Method: Choose Incremental (recommended for large tables) or All (full extraction).
      • Filters: Restrict rows during extraction. For each filter, specify a column, an operator such as equals, not equals, greater than, or less than, and a value.
    • Click Table Target Settings to configure how the data loads into the Target.
  4. Click Table Definitions to define an Advanced Target Definitions.
    • Table Prefix (optional): Add a prefix to Target table names.
    • Default Loading Mode: Choose how data is loaded. If no key columns are defined, Append Only is applied by default.
    • Upsert Merge: Inserts new rows and updates existing rows based on key columns.
    • Merge Method: Select how updates process. For example, Switch - Merge.
    • Filter Logical Key Duplication Between Files: Optionally filter out duplicates in the Source that should not appear in the Target. Use this only when duplicates are expected in the Source but not in the destination table.
    • Click Apply Changes to save your configuration.
  5. Click Bulk Actions to apply settings to multiple tables at once. You can:
    • Select Tables: Choose specific tables, tables by condition, all tables in a schema, or all tables.
    • Bulk Actions: Configure extraction and loading modes, and add calculated columns (+ Add).
    • Summary & Confirmation: Review your selections and click Apply Bulk Action.
  6. Click Reload Metadata to refresh and load the latest version of the available schemas and tables.

Step 5: Scheduling and settings

Scheduling the River

  1. Toggle Schedule River on to run the River automatically.
  2. Set the run frequency and time.

Configuring time-outs

  • Define how long the River should run before timing out. For example, twelve hours.

Configuring notifications (optional)

  1. Add email addresses to receive alerts.
  2. Toggle the type of notifications you want to enable:
    • Failure
    • Warning
    • Run Threshold

Adding River information

  1. Enter a River Name.
  2. Select a Group.
  3. (Optional) Add a Description for the River.

Saving and activating

  1. Click Activate to finalize and enable the River.
  2. Or choose Save & Exit to save without running.

Troubleshooting

  • No views listed: Reload metadata after creating and finalizing views in Boomi for SAP.
  • Invalid filter: Verify that the column supports filtering and that the filter value matches the correct data type.
  • Schema drift: Reload metadata and rerun the River to sync updated structures.
On this Page